SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001419s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1010097 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1010097 [ RunTime:0.002090s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (883695,1009943,417940,696932,424990,533261,721954,309128,4670,162409,631956,464690,887435,537882,816143,542447,496764,443064,378103,410106,628279,7043,518479,664518,590617,432942,712319,856632,790658,845613,866088,966619,911149,578368,332848,408635,715134,532426,272767,191690,307427,592728,122635,645695,130648,784285,2945,52216,844699,306183,926470,574766,284711,111799,371775,509081,736183,517539,535521,821545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1010097 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1010097 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000422s ]