SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534317 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534317 [ RunTime:0.001671s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (181777,708939,1048418,369023,484461,67156,363756,18090,86105,286368,196735,560796,978617,1003214,721888,810038,405084,649843,26118,939300,798396,780030,727213,661707,81523,701994,151132,440270,803708,770200,663230,820201,802534,346364,1048340,109394,28634,97739,164516,554734,24953,723880,195343,233091,67487,841439,279239,418818,1026263,510799,53007,137463,1005529,594583,305566,881217,886225,296019,935974,693467) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001584s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000474s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]