SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001225s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 286580 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 286580 [ RunTime:0.001759s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (877505,843497,417634,869498,120746,689628,195734,587142,752014,415685,766288,867504,31216,882862,379070,461645,809245,13380,483377,33118,903713,275455,717105,661671,53127,578241,834040,1019911,921133,103445,996921,705429,768953,590888,728443,619576,641630,671358,899753,173835,997630,51882,89800,448442,18781,63114,719412,236482,6526,53577,937735,425013,768802,925132,314308,503423,366700,1038840,926194,498137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 286580 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 286580 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001125s ]