SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 424300 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 424300 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (776627,218532,696667,291904,455814,838867,1035766,316750,339423,818152,763649,475486,774457,485939,158047,985556,124840,869136,67874,135557,372630,570357,402850,196584,778070,500431,743181,722322,193466,1028316,62860,614051,999949,140163,67989,916886,558066,688084,804232,1027248,422329,934960,494470,18494,797646,267354,754240,1004517,81644,1039703,598317,154073,213858,149951,793773,483403,654871,250119,316969,888597) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 424300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000510s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 424300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]