SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 409309 LIMIT 1 [ RunTime:0.000583s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 409309 [ RunTime:0.001726s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159033,167031,73473,702738,665976,979424,739668,484946,928848,168811,577090,491995,405089,101004,878626,516007,457728,563136,585372,40838,933052,913180,2696,385705,407956,499077,121281,471754,371762,140656,971402,228170,334665,980038,28287,1022750,731029,748681,525000,984075,395426,433767,990789,1022549,739089,534231,607692,70489,501709,32498,58450,327183,595546,207424,154860,110186,9190,85147,516867,984578) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001025s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 409309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 409309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]