SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001459s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 516992 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 516992 [ RunTime:0.001688s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (360012,584368,927992,598640,206010,756434,699369,987562,695800,438804,338031,32813,710958,472574,760954,165934,1025665,372959,810497,768899,635455,426990,85982,936202,749857,876967,465639,610541,233678,557580,945189,345289,779732,93233,850611,561986,81202,170179,852054,1041440,272363,583660,744283,327467,307994,641926,708384,479302,87214,931758,435201,745426,479759,796561,783865,796229,350839,341100,406768,793769) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 516992 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 516992 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000609s ]