SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 518525 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 518525 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1017672,91888,569260,436096,845696,172337,173814,581516,904232,164298,341046,474563,646736,847865,332308,925268,106952,512681,829121,130072,34964,30205,768893,974925,567021,505913,157539,55882,903249,707555,812658,847173,215413,362742,177870,661041,801286,89136,263028,732770,878764,407285,213930,90462,162528,395673,470761,706072,842275,85425,21420,531336,1033868,340512,660124,308909,682477,896221,745791,498188) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 518525 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 518525 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000763s ]