SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 249644 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 249644 [ RunTime:0.001757s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452557,267163,200270,255099,28334,842237,802816,161201,339497,139728,350562,983204,370978,781773,1015870,411520,31866,649578,801145,429565,1041982,633196,97933,463426,382602,319712,663451,592274,302226,256013,474627,281110,48616,338088,848763,960101,492343,1012636,119199,116612,258774,699555,808930,186937,1042389,173615,1025671,507650,1020136,1033180,102043,750323,573717,984461,896497,95531,372999,813678,922763,242164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 249644 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001643s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 249644 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001289s ]