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` = 105813 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 105813 [ RunTime:0.001898s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (879779,910473,727529,1014836,361451,399910,51027,186075,202507,592441,403471,591727,30849,1036975,439360,905442,850076,38790,720059,344309,537771,217993,606848,275048,541558,37258,812610,439815,109403,571980,398180,994500,670811,709917,465996,313470,195927,368096,890226,597949,542663,479281,875877,416409,259777,952919,322320,386125,122852,113639,237237,953506,303210,145044,703544,451061,499545,243812,775950,441481) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001279s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 105813 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000520s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 105813 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000529s ]