SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001688s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514691 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514691 [ RunTime:0.002049s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (15036,146860,103889,210526,695641,801394,911030,353006,102265,257525,240590,494473,158280,486396,146633,540227,852738,620841,487011,819574,599494,249429,900441,378744,471861,684703,316659,877964,993387,110080,483240,881258,585263,516953,114682,119144,1013681,420063,954245,295413,646530,973576,720707,307125,909983,931878,52014,703940,140665,919340,682195,592616,110518,209795,208643,931287,375785,454461,98492,1036903) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001900s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514691 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000543s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514691 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]