SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001142s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497501 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497501 [ RunTime:0.002325s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (921604,17248,225043,926647,223364,363851,494899,968662,980251,1039587,822059,759500,1016275,917248,801288,580008,735437,197207,95158,827523,932794,227810,56808,976196,539719,306944,848849,243854,999244,600994,11547,669731,515292,273903,80824,258928,113398,846187,495651,966847,188855,539457,945596,877639,308304,147298,85965,636912,807441,641590,307118,692925,70888,683654,316698,65993,1045153,346225,214056,808059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006317s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497501 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001066s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497501 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001196s ]