SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039900 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039900 [ RunTime:0.001944s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (586362,1039273,365712,343248,729654,832951,994311,696686,845023,610857,852987,544912,730846,871734,484642,351366,630368,628406,765029,665330,1044398,380997,42357,877253,962536,872377,666043,366097,991745,1022724,1026781,194077,541865,963212,981750,275196,179600,562720,466805,374482,760038,1025180,1043509,315881,637117,352475,668406,449902,308955,767891,214392,985774,166259,250995,494784,999420,558954,563764,20637,236347) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001852s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039900 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000506s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039900 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000560s ]