SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 60280 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 60280 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (497700,90636,399961,433787,431839,543619,1042977,807038,978932,673369,836606,418450,791939,619063,142373,1036024,764116,857145,823801,333274,1018067,22892,1395,485151,836558,929963,711017,931308,1014900,947355,656276,810692,891015,4328,548571,354790,705566,503528,537601,119565,998184,786458,810391,259530,167017,780714,672044,5711,856640,912783,1034753,856926,767621,399026,428978,908533,515090,250090,483312,938185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 60280 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 60280 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]