SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501784 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501784 [ RunTime:0.006818s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (815677,902684,12469,581872,303865,1043665,204185,638297,915536,314011,593523,994797,148708,631456,1009465,823046,120978,210073,103610,445302,986221,993867,515850,264878,490335,581501,1047959,129750,646321,418548,2649,755786,337556,393829,345114,1041208,673164,1015595,176648,309105,609404,599670,779313,660254,433445,135877,959614,588658,50901,39926,375291,698440,765106,999809,486819,329609,971882,661552,321017,424610) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501784 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501784 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002878s ]