SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001335s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52911 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52911 [ RunTime:0.001645s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1033163,918044,955173,777693,372289,438659,567621,696734,873180,528051,106860,9469,909016,902905,653193,113864,191279,187433,745813,380255,43161,452210,385446,326163,1046856,354419,1003639,414535,974283,96974,587052,911254,1041344,363783,1040531,287617,635390,527026,846183,297106,155047,230201,470580,399721,187566,866285,991086,632581,859702,938807,775847,369389,956805,540747,25349,1035566,471081,797840,130578,95461) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]