SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5028 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5028 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (791842,658627,363959,879116,251600,118191,310404,6496,566132,117729,156218,11343,756143,561963,816115,509362,919398,279123,398099,273409,208597,435486,837079,1019369,2961,120283,131780,891909,738041,932612,838059,349187,1031085,996235,775184,743078,443664,344145,655642,25152,440617,577728,546592,578505,815082,358534,674959,5758,911423,24165,977022,2743,367380,416895,889879,999981,540499,945997,743697,862240) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001047s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5028 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5028 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000943s ]